MIS 44043 F05 Gwebu
Syllabus M&IS 44043 Database Management Systems
General Information
> <br> Instructor: Khole Gwebu
> <br> Instructor: Khole Gwebu
Course Title: Database Management Systems
Semester: Fall 2005
Meeting Room: 324 BSA
Meeting Times: Tuesday & Thursday 05:30PM-06:45PM
Office: MI&S Dept. A402
E-mail: kgwebu@kent.edu
Office Hours: Fri 10:30am- 1:30pm (or by appointment)
Course Prerequisites
M&IS24060 Systems Analysis I
> M&IS24070 Principles Of Systems Development<b><b>
> M&IS24070 Principles Of Systems Development<b><b>
Course Objectives
> <br> Learn the role of databases and database applications in contemporary
> <br> Learn the role of databases and database applications in contemporary
organizations
q Learn and practice data modeling using the entity-relationship model
q Understand the use of SQL and learn SQL syntax
q Understand the special needs of multi-user database processing and learn techniques for controlling the consequences of concurrent data access
q Know the features and functions of a commercial-duty DBMS product and understand how these are implemented in Oracle/SQL Server
q Learn the need for both database administration and data administration
q Learn emerging Internet technology that is relevant to database processing
Textbooks
> <b>
> <b>Required
> <b>
> <b>Required
Title: Database Processing, 8th Edition
> <u>Author: <u>David M. Kroenke
> <u>Publisher: <u>Prentice Hall
> <u>Author: <u>David M. Kroenke
> <u>Publisher: <u>Prentice Hall
Optional (Not required but helpful)
Title: The Complete Reference SQL
Author: J. R. Groff & P.N. Weinberg
Publisher: McGraw Hill
Tentative Schedule
Class Meeting
|
Topics
|
Quizzes
|
Reading Assignment
|
8/30
|
Intro to Course
|
|
Chapter 1
|
9/1
|
Chapter 1- Intro to Database processing
|
|
Chapter 2
|
9/6
|
Chapter 2-Intro to database development
|
|
Chapter 2
|
9/8
|
Chapter 2
|
|
Chapter 3
|
9/13
|
Chapter 3- Data modeling
|
Quiz 1
|
Chapter 3
|
9/15
|
Chapter 3
|
|
Chapter 6
|
9/20
|
Chapter 6-Database Design Using ER Models
|
|
Chapter 6
|
9/22
|
Chapter 6
· Trees Networks and Bills of materials
|
Quiz 2
|
Chapter 5
|
9/27
|
Exam 1
|
|
|
9/29
|
Chapter 5-Normalization
· The Relational Model
· Normalization
|
|
Chapter 5
|
10/4
|
Chapter 5
|
|
Chapter 8
|
10/6
|
Chapter 8-Relational Implementation and Relational algebra
|
|
Chapter 8
|
10/11
|
Chapter 8
|
|
Chapter 9
|
10/13
|
Chapter 9
q An introduction to SQL
|
Quiz 3
|
Chapter 9
|
10/18
|
Chapter 9
Altering tables
|
|
Chapter 9
|
10/20
|
Chapter 9
|
|
Chapter 9
|
10/25
|
Chapter 9
|
|
Chapter 10
|
10/27
|
|
|
Chapter 10
|
11/1
|
Chapter 10-Database application Design
|
Quiz 4 |
Chapter 10
|
11/3
|
Chapter 10
|
|
Chapter 10
|
11/8
|
Chapter 10
|
|
Chapter 11
|
11/10
|
Chapter 11-Managing Multi User Databases
|
|
Chapter 11
|
11/15
|
No Class
|
|
Chapter 12
|
11/17
|
Chapter 11
|
|
Chapter 12
|
11/22
|
No Class
|
|
Chapter 12
|
11/29
|
Chapter 12
|
Quiz 5 |
Chapter 12
|
12/1
|
|
|
|
12/6
|
|
|
|
12/8
|
|
|
|
12/13
|
Exam 2 - Comprehensive
|
5:45 - 8:00 p.m.
Note: Kent State University reserves the right to make adjustments in the Final Exam Schedule
|
|
Grading
> <br> Project --------------------------------------150 points
> <br> Project --------------------------------------150 points
Quizzes 5@40 points each----------------200 points
> <br> Exams-2@ 100 points each---------------200 points
> <br> In Class Exercises -------------------------50 points
> <br> Total ----------------------------------------600 points
> <br> Final Grades
> <br> Please note that the plus/minus grading system will NOT be used in this class. The final grade will be determined as follows:
> <br> Exams-2@ 100 points each---------------200 points
> <br> In Class Exercises -------------------------50 points
> <br> Total ----------------------------------------600 points
> <br> Final Grades
> <br> Please note that the plus/minus grading system will NOT be used in this class. The final grade will be determined as follows:
A = 600 - 540 points
> <br> B = 539 - 480 points
> <br> C = 479 - 420 points
> <br> D = 419 - 360 points
> <br> F = Below 360 points
> <br> B = 539 - 480 points
> <br> C = 479 - 420 points
> <br> D = 419 - 360 points
> <br> F = Below 360 points
Once grades are posted on the course website, you have three days to let me know by e-mail, if you feel a mistake has been made in your grade. If you fail to contact me about your grade within this three day period, then the grade for the homework or quiz, even if incorrect, will be final.
Note: The last day to withdraw from this course is Nov. 6 2005.
Readings
This course is designed to help you develop skills that will serve you in an ever changing professional environment. In particular, your text and any other supplementary materials you may acquire are resources to help you master important concepts. You should take the extra time to familiarize yourself with them.
Class attendance
Class attendance is not required, however, it is expected and, you are responsible for all material covered in class in addition to that assigned outside of class. Occasionally, there will be random in-class exercises assigned during class time. If you miss a class you will not be able to “make-up” these exercises. The only exception to this rule is in very rare situations where you will have to notify me in writing (along with any supporting evidence
e.g. a doctor’s note) at as to why you were not able to attend class. Thereafter, I will make a decision as to whether the reason given for missing the class is warranted to allow you to “make-up” the missed exercises.
A note on class decorum:
I interpret your coming to class as an expression of your interest in learning as much as you possibly can. Certainly, you should assume that this is your classmates' intention in being here. In fairness to your classmates and I, expect you to refrain from talking to others, reading newspapers, sleeping, playing radios or CDs, making or receiving phone calls and other similar, disruptive activities. Don't be surprised if I ask you or someone else to leave because of conduct detrimental to the class. If you simply must study for a test later that day, stay home, go to the Library, find a bench outdoors. Don't do it in class.
Excuses
No make-up quizzes , in-class exercises, projects or exams will be given unless excused by university policy.
> <br>
> <br>
Students with Disabilities
In accordance with University policy, if you have a disability and require accommodations to obtain equal access in this course, please contact me at the beginning of the semester or when given an assignment for which an accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) in the Michael Schwartz Student Services Center (672-3391).
Academic Dishonesty
It is expected that all work you submit for a grade will be your own. If this is not the case, a failing grade will be assigned for this course and the instructor reserves the right to pursue additional sanctions as provided by University rules and regulations. If you are not familiar with these rules and regulations, you can find them in the current University Phone Directory.
In particular, each of you must submit your own work. Should two or more of you submit identical or substantially identical assignments/quizzes/exams/projects, then I can only assume that one (or more) of you copied from the other(s). In such a circumstance, every student involved will receive a failing grade for the course. Additional sanctions may be pursued in accord with University rules and regulations.
Enrollment/Official Registration
Students have responsibility to ensure they are properly enrolled in classes. You are advised to review your official class schedule during the first two weeks of the semester to ensure you are properly enrolled in this class and section. Should you find an error in your class schedule, you have until Sunday, September 4, 2005 to correct it with your advising office. If registration errors are not corrected by this date and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester for any class in which you are not properly registered.
Note: The instructor reserves the right to amend the syllabus at any time during the course of the semester.